MacWorld 1998 January/Macworld (1998-01).dmg/FileMaker Pro 4/FM4 Templates w⁄data/Business/Purchase Orders

FileMaker Pro Database | 1997-09-14 | 115KB | 731 lines

Consult
ClarisII
CLARISII
Personnel Records.fp3
PERSON~1.FP3
HARDDISK
\\PAULFARRAH\C
CONSULT\ClarisII\v3\Personnel Records.fp3
..\..\CONSULT\ClarisII\v3\Personnel Records.fp3
C:\CONSULT\ClarisII\v3
a[',>
HBAM2016AUG95
Pro 3.0
Nz2N3
[ov5G
ORDER TOTAL
HBAM3016AUG95@
HP DeskJet 540 Printer
Pro 2.0 - 2.1F!
Pro 3.0
BILL TO CITY
BILL TO COMPANY
BILL TO ID
BILL TO NAME
BILL TO STATE
BILL TO STREET
BILL TO ZIP CODE
CREATED BY
DATE CREATED
DATE MODIFIED
DISCOUNT
DISCOUNT RATE
F.O.B.
EOTAL
PRODUCT DESCRIPTION
PRODUCT EXTENDED AMOUNT
PRODUCT ID
PRODUCT QUANTITY
PRODUCT UNIT PRICE
PURCHASE ORDER ID
REQUESTED BY
5    SALES TAX
SALES TAX RATE
-    SHIP DATE
SHIP TO CITY
SHIP TO COMPANY
SHIP TO ID
SHIP TO NAME
SHIP TO STATE
SHIP TO STREET
SHIP TO ZIP CODE
SHIP VIA
SHIPPING
SUBTOTAL
SUPPLIER CITY
SUPPLIER COMPANY
SUPPLIER ID
SUPPLIER STATE
SUPPLIER STREET
SUPPLIER ZIP CODE
TERMS
WEIGHT
    USENG.NDX
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
11/20/95
A    Form View
A    List View
Purchase Order Report
Information
Report Menu
A    Form ViewB
Purchase Order IDB
Bill To NameB
DateB
Bill To StreetB
Bill To StateB
Bill To ZIP CodeB
Date CreatedB
Date ModifiedB
Ship To NameB
Bill To CityB
Bill To CompanyB
Ship To CompanyB
Ship To StreetB
Ship To CityB
Ship To StateB
Ship To ZIP CodeB
Product IDB
Product DescriptionB
Product QuantityB
Product Unit PriceB
+roduct QuantityB
Product Unit PriceB
Product Extended AmountB
) ) *
SubtotalB
Sales Tax RateB
.A    Sales TaxB
4) *
ShippingB
Order TotalB
Discount RateB
DiscountB
Requested ByB
7A    Ship DateB
TermsB
Net 30
F.O.B.B
Ship ViaB
Ground
WeightB
Created ByB
Supplier CompanyB
Supplier StreetB
Supplier CityB
Supplier State
Supplier ZIP CodeB
Supplier IDB
Bill To IDB
Ship To IDB
InfoB
Description
Use this database file to track purchase orders.  FileMaker Pro automatically calculates sales tax and product discounts.
How to use this solution
You can update the sales tax and discount rate by updating the values in those fields. The Purchase Order report prints a typical purchase order form.
How to customize this solution
You can create lookups in this file to your own product database file or even your suppliers' files. A lookup based on Product ID can find information B
for Description and Price. A lookup based on Supplier Company can enter information such as the supplier's address and discount rate.
A    List ViewB
Your Own
Button
Your Own
Button
Record
Delete
Record
Record
Reports
Your Own
Button
Your Own
Button
Record
Delete
Record
Record
Reports
View As
View As
Close
Total
Shipping
Discount
Subtotal
Requested By
Weight
Ship Via
    Ship Date
F.O.B.
Terms
Extended Amount
Price
Description
Prod. ID
Supplier
P.O. No.
Ship To
Bill To
Enter data for Purchase Orders
Purchase Order ReportB
TotalW
Requested ByX
SupplierY
DateZ
Order ID[
Your Own
Button\
Your Own
Button]
Record^
Delete
Record_
Record`
Reportsa
View As
Listb
View As
Formc
Closed
Infoe2Click to see more information for a Purchase Order
InformationB
Your Own
Button
Reports
View As
View As
Close
Extended Amount
Price
Quantity
Description
Product ID
Weight:
Total:
h    Shipping:
j    Discount:
k    Subtotal:
Ship Via
m    Ship Date
F.O.B.
Terms
Requested By
Ship To
Bill To
Supplier
P.O. No.
Purchase Order
Company Name and Logo
ABCE>>, <<
ABCF>> <<
ABCG>>
ABCA>>, <<
ABAI>> <<
ABAK>>
ABDP>>, <<
ABEA>> <<
ABEB>>
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO.Information about the Purchase Orders solutionk purchase orders.  FileMaker Pro automatically calculates sales tax and product discounts.
How to use this solution
You can update the sales tax and discount rate by updating the values in those fields
How to customize this solution
You can create lookups in this file to your own product database file or even your supplier's files.
O.Information about the Purchase Orders solutionn those fields
How to customize this solution
You can create lookups in this file to your own product database file or even your supplier's files.
O.Information about the Purchase Orders solution
Info for this Solution
Your Own
ReportB
Your Own
ReportC
Your Own
ReportD
Purchase Order ReportE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
Joel DavisE
05/05/95G
2301 Pennings CircleH
87154Y
5/27/95_
Lauren Petersen`
Santa Fea
Acme Industriesb
Acme Industriesc
2301 Pennings Circled
Santa Fee
87154g
H107h
File Storage Drawer
Full Strip Stapler
3-Hole Punchi
155.3m
10.56q
147.56s
23.3u
Paula Jonesw
6/25/94x
Net 30y
New Yorkz
Ground{
23 lbs.}
Joe's Office Supply~
1414 S. Lincoln Avenue
Athens
24232
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Sort by Date
Sort by Supplier
Sort by Requested By
Purchase Order Report
Open Script
Sort by Date
Purchase Order Report
Sort by Supplier
Sort by Requested By
Open Script
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
)=400
ecision )
Upper ( text )
CancelYear ( date ))
WeekofYearFi
cal ( date , starting
day )
WordYou did not enter any find criteria; all records will be displayed.C,
) = 0
ecision )
Upper ( text )
CancelYear ( date ))
WeekofYearFi
cal ( date , starting
day )
WordNo records match this request.E,
) = 1
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
(LIST
LISTA
Ground
VDEFA(
Ship Via List
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
    ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
"%UR
UD33D
AD@D@
AD@D@
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
44444
CCCCC 44444 CCCCC
$42"
bRBBP0
@@BA@
 JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
 *00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
UUUUU
(*)(%,3&
)%+@6)
",30,)%
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%Q
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFG
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
ORDER TOTAL
PRODUCT DESCRIPTION
PRODUCT EXTENDED AMOUNT
PRODUCT ID
PRODUCT QUANTITY
PRODUCT UNIT PRICE
PURCHASE ORDER ID
REQUESTED BY
5    SALES TAX
SALES TAX RATE
-    SHIP DATE
SHIP TO CITY
SHIP TO COMPANY
SHIP TO ID
SHIP TO NAME
SHIP TO STATE
SHIP TO STREET
SHIP TO ZIP CODE
SHIP VIA
SHIPPING
SUBTOTAL
SUPPLIER CITY
SUPPLIER COMPANY
SUPPLIER ID
SUPPLIER STATE
SUPPLIER STREET
SUPPLIER ZIP CODE
TERMS
WEIGHT